package com.ctshk.rpc.order.tour.mapper;

import org.apache.ibatis.annotations.Param;
import org.apache.ibatis.jdbc.SQL;

/**
 * <p>
 * 系列团游客收款 Provider 接口
 * </p>
 *
 * @author 谭响
 * @since 2021-01-18
 */
public class SeriesOrderCollectionProvider {

    public String reciveListByTourist(@Param("id")Long id){
        return new SQL() {{
            SELECT("a.id,b.cn_fullname,b.en_fullname,a.collection_number,a.paid_in_amount,a.collection_type,a.collection_way,a.currency_type,a.payer,a.remark,a.`status`,a.reject_msg,a.gmt_create,a.create_id");
            FROM("t_series_order_collection a");
            LEFT_OUTER_JOIN("t_series_order_tourist_info b ON a.tourist_id = b.id");
            WHERE("a.tourist_id = #{id} AND a.is_deleted=0" );
        }}.toString();
    }
}
